package com.hs.server.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hs.server.domain.ShResourcexxRecord;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

public interface ShResourcexxRecordMapper extends BaseMapper<ShResourcexxRecord> {
    @Select("SELECT shrq FROM sh_resourcexx_record WHERE ipdz = #{ipdz} ORDER BY shrq desc LIMIT 1")
    String getLastDate(String ipdz);

    @Select("SELECT * FROM sh_resourcexx_record WHERE ipdz = #{ipdz} AND shrq = #{date}")
    ShResourcexxRecord getShResourcexxRecord(String ipdz,String date);
}
